﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Text;

namespace Model
{
    public class Personnel  //人员表
    {
        [Key]
        public int staff_ID { get; set; }//人员标识
        public string staff_NAME { get; set; }//姓名
        public string staff_CODE { get; set; }//工号
        public string staff_alias { get; set; }//人员说明
        public string username { get; set; }//用户名
        public string password { get; set; }//密码
        public string email { get; set; }//电子邮件
        public string home_tel { get; set; }//家庭电话
        public string Address { get; set; }//地址
        //public int Depar_ID { get; set; }//所在部门
        //[ForeignKey("Depar_ID")]
        //public virtual Department Department { get; set; }
        public int State_ID { get; set; }//状态
        [ForeignKey("State_ID")]
        public virtual Tstate State { get; set; }
        public string certificates { get; set; }//证件号码
        public string sex { get; set; }//性别
        public string Entry { get; set; }//入职时间
        public int Job_ID { get; set; }//职称
        [ForeignKey("Job_ID")]
        public virtual Position Position { get; set; }
        public int Role_ID { get; set; }//角色编号
        [ForeignKey("Role_ID")]
        public virtual Role Role { get; set; }
        public string remarks { get; set; }//备注
    }
}
